package com.financing.wap.common;

/**
 * Ibatis配置文件sqlMaping
 * @author hetaihe
 *
 */
public class SqlName {
	
	/**
	 * 命名空间分隔符
	 */
	private static final String SEPARATOR = ".";
	
	/**
	 * 命名空间：系统公共sql
	 */
	private static final String COMMON_NAMESPACE = "common" + SEPARATOR;
	/**
	 * 查询UUID
	 */
	final static public String queryUUID = "common.queryUUID";

	/**
	 * 命名空间：用户
	 */
	private static final String USER_NAMESPACE = "user" + SEPARATOR;
	
	/**
	 * 命名空间：产品
	 */
	private static final String PRODUCT_NAMESPACE = "product" + SEPARATOR;
	
	/**
	 * 命名空间：订单
	 */
	private static final String ORDER_NAMESPACE = "order" + SEPARATOR;
	
	/**
	 * 命名空间：FA认证
	 */
	private static final String AUTHENTICATION_NAMESPACE = "authentication" + SEPARATOR;
	
	/**
	 * 命名空间:机构账号邀请码
	 */
	private static final String COMPANY_INVITATION_CODE_NAMESPACE = "companyInvitationCode"+SEPARATOR;
	
	/**
	 * 命名空间：系统
	 */
	private static final String SYSTEM_NAMESPACE = "system" + SEPARATOR;
	
	/**
	 * 命名空间：消息
	 */
	private static final String MESSAGE_NAMESPACE = "message" + SEPARATOR;
	
	/**
	 * 命名空间：日程管理
	 */
	private static final String SCHEDULE_NAMESPACE = "schedule" + SEPARATOR;
	
	/**
	 * 命名空间：机构管理
	 */
	private static final String CORP_NAMESPACE = "corp"+SEPARATOR;
	
	
	/**
	 * 命名空间：账户管理
	 */
	private static final String ACCOUNT_NAMESPACE = "account"+SEPARATOR;
	
	/**
	 * 命名空间：客户管理
	 */
	private static final String CLIENT_NAMESPACE = "client"+SEPARATOR;
	
	/**
	 * 命名空间：新闻资讯
	 */
	private static final String NEWS_NAMESPACE = "news"+SEPARATOR;
	
	/**
	 * 命名空间：快速预约
	 */
	private static final String VISITRECORD_NAMESPACE="visitRecord"+SEPARATOR;
	
	/**
	 * 命名空间：订单流水
	 */
	private static final String ORDERFLOW_NAMESPACE="orderFlow"+SEPARATOR;
	
	/**
	 * 命名空间：活动礼品
	 */
	private static final String ACTIVITIE_GIFT = "activitieGift"+SEPARATOR;
	
	/**
	 * 命名空间：wap订单预约
	 */
	private static final String ORDER_TMP = "ordertmp"+SEPARATOR;
	
	/**
	 * 命名空间：产品收藏
	 */
	private static final String PROJECT_LIKE = "projectLike"+SEPARATOR;
	/**
	 * 命名空间：公共活动
	 */
	private static final String PUBLIC_ACTIVITIES_PERSON = "publicActivitiesPerson"+SEPARATOR;
	/**
	 * 命名空间：用户行为统计
	 */
	private static final String USER_TRACKING ="userTracking"+SEPARATOR;
	
	/**
	 * 命名空间：调查问卷
	 */
	private static final String ANSWER_TRACKING ="answer"+SEPARATOR;
	
	/**
	 * 命名空间：活动团组名称
	 */
	private static final String ACITIVIES_GROUP_NAME = "activitiesGroupName"+SEPARATOR;
	
	/**
	 * 命名空间：活动
	 */
	private static final String ACTIVITIES_GROUP = "activitiesGroup"+SEPARATOR;
	
	/**
	 * 命名空间：活动
	 */
	private static final String ACTIVITES_ACTIVITES ="activites"+SEPARATOR;
	
	/**
	 * 用户反馈
	 */
	private static final String USER_FEED_BACK="userFeedBack"+SEPARATOR;
	
	/**
	 * 命名空间：活动报名表
	 */
	private static final String PUBLIC_ACTIVITIES = "publicActivities"+SEPARATOR;
	

	/**
	 * 命名空间：产品公司
	 */
	private static final String PROJECT_COMPANY = "projectCompany"+SEPARATOR;
	
	/**
	 * 命令空间:海外保险命名空间
	 */
	private static final String HYBX_ORDER_NAMESPACE = "hybxOrder" + SEPARATOR;
	

	/**
	 * 命名空间：信息订阅
	 */
	private static final String INFO_SUBSCRIBE = "infoSubscribe"+SEPARATOR;
	

	/**
	 * 命名空间：广告
	 */
	private static final String ADVERT = "advert"+SEPARATOR;
	
	/**
	 * 命名空间：用户微信信息
	 */
	private static final String WECHAT = "userWechat"+SEPARATOR;
	
	/**
	 * 命名空间：极光推送用户手机绑定
	 */
	private static final String MESSAGEJPUSHUSERPHONEALIAS = "messageJpushUserPhoneAlias"+SEPARATOR;
	
	/**
	 * 命名空间：百万财富活动
	 */
	private static final String ACTIVITIESMOLLIONSWEALTH="activitesMollionsWealth"+SEPARATOR;
	
	/**
	 * 命名空间：用户私募管理办法
	 */
	private static final String USERAGREEAGREEMENT = "userAgreeAgreement"+SEPARATOR;
	
	/**
	 * 查询uuid
	 */
	public static final String QUERY_UUID = COMMON_NAMESPACE + "queryUUID";
	
	/**
	 * 查询当前版本
	 */
	public static final String QUERY_VERSIONNO = COMMON_NAMESPACE + "queryVersionNo";
	
	
	/**
	 * 根据用户名和密码查询用户
	 */
	
	public static final String USER_QUERY_NAMEPASSWORD = USER_NAMESPACE + "queryUserByNameAndPassword";
	/**
	 * 根据用户名和密码查询用户
	 */
	public static final String USER_QUERY_LOGIN_NAME = USER_NAMESPACE + "queryUserByLoginName";
	
	/**
	 * 根据用户ID查询用户
	 */
	public static final String USER_QUERY_USERID = USER_NAMESPACE + "queryUserByUserId";
	
	/**
	 * 更新fa信息
	 */
	public static final String USER_UPDATE_USERINFO = USER_NAMESPACE + "updateFaUserInfo";
	
	
	/**
	 * 机构账号邀请码获取
	 */
	public static final String COMPANY_INVITATION_CODE = COMPANY_INVITATION_CODE_NAMESPACE+"queryCompanyInvitationCode";
	
	
	/**
	 * 根据用户ID查询用户证书
	 */
	public static final String USER_CERT_QUERY_USERID = USER_NAMESPACE + "queryUserCertListByUserId";
	
	/**
	 * 根据用户ID查询用户证书
	 */
	public static final String USER_COUNT_SOURCE_CODE = USER_NAMESPACE + "queryCountBySourceCode";
	
	
	/**
	 * 用户注册
	 */
	public static final String USER_REGISTER = USER_NAMESPACE + "register";
	
	/**
	 * 用户答题通过自动认证
	 */
	public static final String UPDATE_FAUSERINFO_AUTOPASS = USER_NAMESPACE + "updatefaUserInfoAutoPass";
	
	
	/**
	 * 根据用户名(手机号码,判断用户是否已经注册)
	 */
	public static final String USER_ISEXIST = USER_NAMESPACE + "isExist";
	
	/**
	 * 根据用户名查询用户信息
	 */
	public static final String USER_QUERY_MOBILE = USER_NAMESPACE + "queryUserByMobile";
	
	/**
	 * 根据用户名id查询用户信息
	 */
	public static final String USER_QUERY_BYID = USER_NAMESPACE + "queryUserByid";
	
	/**
	 * 根据参数查询用户信息
	 */
	public static final String USER_QUERY = USER_NAMESPACE + "queryUser";
	
	/**
	 * 查询邀请理财列表
	 */
	public static final String INVITE_USER_QUERY_BYID = USER_NAMESPACE + "queryInviteUserByid";
	
	/**
	 * 下订单
	 */
	public static final String HYBX_ORDER_INSERT =  HYBX_ORDER_NAMESPACE + "hybxOrderInsert";
	
	/**
	 * 查询邀请理财列表总数
	 */
	public static final String INVITE_USER_QUERY_BYID_COUNT = USER_NAMESPACE + "queryInviteUserByidCount";
	
	/**
	 * 查询机构理财师
	 */
	public static final String queryOrgUser = USER_NAMESPACE + "queryOrgUser";
	
	/**
	 * 查询机构理财师数
	 */
	public static final String queryOrgUserCount = USER_NAMESPACE + "queryOrgUserCount";
	
	/**
	 * 返回自定义字段
	 */
	public static final String queryMapUser = USER_NAMESPACE + "queryMapUser";
	
	public static final String PRODCUT_QUERY_LISTN = PRODUCT_NAMESPACE + "queryProdcutListN"; 
	
	public static final String PRODCUT_QUERY_LIST_COUNTN = PRODUCT_NAMESPACE + "queryProdcutListCountN";//搜索
	
	public static final String PRODCUT_QUERY_LIST = PRODUCT_NAMESPACE + "queryProdcutList";
	
	public static final String QUERY_HEIGH_SEARCH_COUNT = PRODUCT_NAMESPACE + "queryHeighSearchCount";
	
	public static final String PRODCUT_PEVC_QUERY_LIST = PRODUCT_NAMESPACE + "queryProdcutPEVCList";//PEVC 列表 
	
	public static final String PRODCUT_QUERY_LIST_COUNT = PRODUCT_NAMESPACE + "queryProdcutListCount";
	
	public static final String PRODCUT_PEVC_QUERY_LIST_COUNT = PRODUCT_NAMESPACE + "queryProdcutPEVCListCount";//PEVC 列表 count
	
	public static final String ORDER_QUERY_LIST = ORDER_NAMESPACE + "queryOrderList";
	
	public static final String ORDER_QUERY_LIST_COUNT = ORDER_NAMESPACE + "queryOrderListCount";
	
	public static final String ORDER_LIST_COUNT = ORDER_NAMESPACE + "orderListCount";
	
	public static final String ORDER_TIMES_COUNT = ORDER_NAMESPACE + "orderTimesCount";
	
	public static final String ORDER_TIMES_COUNT_DONE = ORDER_NAMESPACE + "orderTimesCountDone";
	
	public static final String ORDER_COUNT_BYTIMESANDORG = ORDER_NAMESPACE + "orderCountByTimeAndOrg";
	
	public static final String QUERY_ORDER_XAXIS = ORDER_NAMESPACE + "queryOrderXaxisDatas";
	
	public static final String ORDER_COUNT_BYTIMESANDORG_DONE = ORDER_NAMESPACE + "orderCountByTimeAndOrgDone";
	
	public static final String QUERY_COUNT_ORDERDONE = ORDER_NAMESPACE + "queryCountOrderDone";
	
	public static final String QUERY_ORDERDONE_BY_WHERECONDITION = ORDER_NAMESPACE + "queryOrderDoneByWherecondition";
	
	public static final String CORP_ORDER_QUERY_LIST = ORDER_NAMESPACE + "queryCorpOrderList";
	
	public static final String CORP_ORDER_QUERY_LIST_COUNT = ORDER_NAMESPACE + "queryCorpOrderListCount";
	
	public static final String ORDER_QUERY = ORDER_NAMESPACE + "queryOrder";
	

	
	/*评论*/
	public static final String PRODCUT_COMMENTS_QUERY_LIST = PRODUCT_NAMESPACE + "queryProdcutCommentsList";
	public static final String PRODCUT_COMMENTS_COUNT_LIST = PRODUCT_NAMESPACE + "countProdcutCommentsList";
	public static final String PRODCUT_COMMENTS_QUERY = PRODUCT_NAMESPACE + "queryProdcutComments";
	public static final String PRODCUT_COMMENTS_ADD = PRODUCT_NAMESPACE + "addProdcutComments";
	public static final String PRODCUT_COMMENTS_ADD_LINK = PRODUCT_NAMESPACE + "addProdcutCommentsLink";
	public static final String PRODCUT_COMMENTS_UPDATE_UPUPCOUNT = PRODUCT_NAMESPACE + "updateProdcutCommentsUpCount";
	public static final String QUERY_COMMENTS_LINK = PRODUCT_NAMESPACE + "queryCommentsLink";
	
	/**
	 * 变更订单状态
	 */
	public static final String ORDER_CHANGE_STATUS = ORDER_NAMESPACE + "changeStatus";
	    
	/**
	 * 申请预约
	 */
	public static final String APPLY_PRE = ORDER_NAMESPACE + "applyPre";
	
	/**
	 * 提交认证资料
	 */
	public static final String AUTHENTICATION_SUBMIT = AUTHENTICATION_NAMESPACE + "submit";
	
	/**
	 *修改
	 */
	public static final String authenticationUpdate = AUTHENTICATION_NAMESPACE + "authenticationUpdate";
	
	/**
	 * 提交证书信息
	 */
	public static final String AUTHENTICATION_CERT_SUBMIT = AUTHENTICATION_NAMESPACE + "certSubmit";
	
	/**
	 * 删除证书信息
	 */
	public static final String AUTHENTICATION_CERT_DELETE = AUTHENTICATION_NAMESPACE + "certDelete";
	
	/**
	 * 删除认证资料
	 */
	public static final String AUTHENTICATION_DELETE = AUTHENTICATION_NAMESPACE + "deleteSubmit";
	
	/**
	 * 查询认证资料
	 */
	public static final String AUTHENTICATION_AUTH_QUERY = AUTHENTICATION_NAMESPACE + "queryAuthInfo";
	
	/**
	 * 查询认证资料
	 */
	public static final String AUTHENTICATION_CERT_LIST = AUTHENTICATION_NAMESPACE + "queryCertList";
	
	

	public static final String SYSTEM_STWICH = SYSTEM_NAMESPACE + "switch";
	
	public static final String SYSTEM_ADMIN_USER_INFO = SYSTEM_NAMESPACE+"queryAdminUserById";
	
	
	public static final String PLATFORM_MONTH_REBATE  = SYSTEM_NAMESPACE+"queryMonthRebate";
	
	public static final String MOLLIONS_WEALTH_COUNT = SYSTEM_NAMESPACE+"queryMollionsWealthCount";
	
	/**
	 * 消息列表
	 */
	public static final String MESSAGE_LIST = MESSAGE_NAMESPACE + "queryMessageList";
	
	/**
	 * 消息列表
	 */
	public static final String MESSAGE_LIST_COUNT = MESSAGE_NAMESPACE + "queryMessageCount";
	
	
	/**
	 * 消息详情
	 */
	public static final String MESSAGE_VIEW = MESSAGE_NAMESPACE + "queryMessageView";
	
	/**
	 * 消息详情
	 */
	public static final String UPDATE_MESSAGE_STATUS = MESSAGE_NAMESPACE + "updateMessageStatus";
	
	/**
	 * 新建日程任务
	 */
	public static final String SCHEDULE_ADD = SCHEDULE_NAMESPACE + "add";
	
	/**
	 * 新建日程任务
	 */
	public static final String SCHEDULE_LIST = SCHEDULE_NAMESPACE + "list";
	
	/**
	 * 新建日程任务
	 */
	public static final String SCHEDULE_LIST_CONUT = SCHEDULE_NAMESPACE + "listCount";
	
	/**
	 * 新建日程任务
	 */
	public static final String SCHEDULE_TASK_UPDATE_STATUS = SCHEDULE_NAMESPACE + "updateTaskStatus";
	
	public static final String SCHEDULE_TASK_QUERY_BY_ID = SCHEDULE_NAMESPACE + "queryTaskById";
	
	/**
	 * 新建日程任务
	 */
	public static final String SCHEDULE_TASK_LIST = SCHEDULE_NAMESPACE + "taskList";
	/**
	 * 新增机构下属FA
	 */
	public  static final String CORP_INSERT = CORP_NAMESPACE + "addCorpUserInfo"; 
	
	/**
	 * 获取机构下属FA
	 */
	public  static final String CORP_FA_LIST = CORP_NAMESPACE + "getCorpFaUserList"; 
	
	/**
	 * 获取机构下属FA
	 */
	public  static final String CORP_FA_VIEW = CORP_NAMESPACE + "getCorpFaUserView"; 
	
	
	/**
	 * 获取机构下属FA总记录数
	 */
	public  static final String CORP_FA_COUNT = CORP_NAMESPACE + "getCorpFaUserCount"; 
	
	
	/**
	 * 获取机构部门详情
	 */
	public  static final String CORP_DEPT_VIEW = CORP_NAMESPACE + "getCorpDeptViewById"; 
	
	
	/**
	 * 获取机构部门信息
	 */
	public  static final String CORP_DEPT_LIST = CORP_NAMESPACE + "getCorpDeptList"; 
	
	/**
	 * 新增机构部门
	 */
	public  static final String CORP_DEPT_INSERT = CORP_NAMESPACE + "insertCorpDeptInfo"; 
	
	/**
	 * 更新机构部门
	 */
	public  static final String CORP_DEPT_UPDATE = CORP_NAMESPACE + "updateCorpDeptInfo"; 
	
	/**
	 * 部门账户信息
	 */
	public static final String ACCOUNT_CORP_INFO= ACCOUNT_NAMESPACE + "getAccountCorpInfo";
	
	/**
	 * 账户组成详情列表
	 */
	public static final String ACCOUNT_CORP_DETAIL_LIST= ACCOUNT_NAMESPACE + "getCorpAccountDetailList";
	
	/**
	 * 账户组成详情数
	 */
	public static final String ACCOUNT_CORP_DETAIL_COUNT= ACCOUNT_NAMESPACE + "getCorpAccountDetailCount";
	
	
	/**
	 * 修改可提现额度
	 */
	public static final String UPDATE_ACCOUNT_BALANCE_ACTIVITY= ACCOUNT_NAMESPACE + "updateAccountBalanceActivity";
	
	/**
	 * 命名空间：银行卡
	 */
	private static final String BANK_CARD = "bankCard"+SEPARATOR;
	/**
	 * 命名空间：提现
	 */
	private static final String ACCOUNT_WITHDRAW = "accountWithdraw"+SEPARATOR;
	
	/**
	 * 查看FA的账户信息
	 */
	public static final String ACCOUNT_USER= ACCOUNT_NAMESPACE + "getFaAccountByUserId";
	
	/**
	 * 个人销售业绩
	 */
	public static final String AMOUNT_USER= ACCOUNT_NAMESPACE + "getCorpUserAmount";
	
	/**
	 * 个人销售业绩(记录总数)
	 */
	public static final String AMOUNT_USER_COUNT= ACCOUNT_NAMESPACE + "getCorpUserAmountCount";
	
	
	/**
	 * 部门销售业绩
	 */
	public static final String AMOUNT_DEPT= ACCOUNT_NAMESPACE + "getCorpDeptAmount";
	
	/**
	 * 总销售业绩
	 */
	public static final String AMOUNT_ALL= ACCOUNT_NAMESPACE + "getCorpAllAmount";
	
	/**
	 * 添加用户账户信息
	 */
	public static final String USER_ACCOUNT_ADD = ACCOUNT_NAMESPACE + "addUserAccount";
	
	/**
	 * 添加用户账户明细
	 */
	public static final String USER_ACCOUNT_DETAIL_ADD = ACCOUNT_NAMESPACE + "addUserAccountDetail";
	
	/**
	 * 个人账户记录数
	 */
	public static final String USER_ACCOUNT_DETAIL_COUNT= ACCOUNT_NAMESPACE + "getUserAccountDetailCount";
	
	
	/**
	 *个人账户明细列表
	 */
	public static final String USER_ACCOUNT_DETAIL_LIST= ACCOUNT_NAMESPACE + "getUserAccountDetailList";
	
	/**
	 *客户列表
	 */
	public static final String CLIENT_USER_LIST= CLIENT_NAMESPACE + "getClientUserBaseInfoList";
	
	/**
	 *客户列表数
	 */
	public static final String CLIENT_USER_LIST_COUNT= CLIENT_NAMESPACE + "getClientUserBaseInfoListCount";
	
	/**
	 *根据iD获取客户信息
	 */
	public static final String CLIENT_USER_INFO_ID= CLIENT_NAMESPACE + "searchClientUserBaseById";
	
	/**
	 *新增客户消息
	 */
	public static final String CLIENT_USER_INSERT= CLIENT_NAMESPACE + "insertClientUserBase";
	
	/**
	 *更新客户消息
	 */
	public static final String CLIENT_USER_UPDATE= CLIENT_NAMESPACE + "updateClientUserBaseById";
	
	/**
	 *机构查看客户
	 */
	public static final String CLIENT_CORP_LIST= CLIENT_NAMESPACE + "getCorpClientUserBaseInfoList";
	
	/**
	 *机构查看客户数
	 */
	public static final String CLIENT_CORP_LIST_COUNT= CLIENT_NAMESPACE + "getCorpClientUserBaseInfoListCount";
	
	/**
	 * 添加客户风险
	 */
	public static final String CLIENT_CORP_INSERT_RISKANSWER= CLIENT_NAMESPACE + "insertClientRiskAnswer";
	/**
	 * 删除客户风险
	 */
	public static final String CLIENT_CORP_DELETE_RISKANSWER= CLIENT_NAMESPACE + "deleteClientRiskAnswer";
	
	
	/**
	 *资讯列表
	 */
	public static final String NEWS_INFO_LIST_COUNT= NEWS_NAMESPACE + "getNewsListCount";
	
	/**
	 *资讯列表数
	 */
	public static final String NEWS_INFO_LIST= NEWS_NAMESPACE + "getNewsList";
	
	/**
	 *资讯详情
	 */
	public static final String NEWS_INFO_VIEW= NEWS_NAMESPACE + "searchNewsById";
	
	
	/**
	 * 产品相关资讯
	 */
	public static final String NEWS_ABOUT_PRODUCT_LIST= NEWS_NAMESPACE + "getAboutNewsByPid";
	
	/**
	 * 产品相关资讯数
	 */
	public static final String NEWS_ABOUT_PRODUCT_COUNT= NEWS_NAMESPACE + "getAboutNewsByPidCount";
	
	/**
	 * 资讯相关产品
	 */
	public static final String NEWS_ABOUT_LIST= NEWS_NAMESPACE + "getAboutProductsByPid";
	
	/**
	 * 资讯相关产品数
	 */
	public static final String NEWS_ABOUT_COUNT= NEWS_NAMESPACE + "getAboutProductsByPidCount";
	
	/**
	 * 标签相关产品数
	 */
	public static final String NEWS_ABOUT_TAG_PRODUCT_LIST= NEWS_NAMESPACE + "getAboutTagProductsByPid";
	
	/**
	 * 标签相关产品数
	 */
	public static final String NEWS_ABOUT_TAG_PRODUCT_COUNT= NEWS_NAMESPACE + "getAboutTagProductsByPidCount";
	
	/**
	 * 标签相关资讯
	 */
	public static final String NEWS_ABOUT_TAG_LIST= NEWS_NAMESPACE + "getAboutTagNewsByPid";
	
	/**
	 * 标签相关资讯数
	 */
	public static final String NEWS_ABOUT_TAG_COUNT= NEWS_NAMESPACE + "getAboutTagNewsByPidCount";

	/**
	 * 新增快速预约记录
	 */
	public static final String VISIT_RECORD_INSERT= VISITRECORD_NAMESPACE + "insertVisitRecord";
	

	/**
	 * 消息新增
	 */
	public static final String MESSAGE_MAIL_INSERT = MESSAGE_NAMESPACE + "insertMailMessageInfo";
	
	/**
	 * 添加短信息
	 */
	final static public String MESSAGE_SMS_INSERT = MESSAGE_NAMESPACE + "addMessageSms";
	
	/**
	 * 添加系统日志
	 */
	final static public String addLogs = "logs.addLog";
	
	/**
	 * 新增订单流水
	 */
	final static public String ORDER_FLOW_INSERT = ORDERFLOW_NAMESPACE + "insertOrderFlow";
	
	/**
	 * 添加活动礼品
	 */
	final static public String ACTIVITIE_GIFT_ADD = ACTIVITIE_GIFT+"insertActiviteGift";
	
	/**
	 * 更新礼品信息
	 */
	final static public String ACTIVITIE_GIFT_UPDATE = ACTIVITIE_GIFT+"updateActiviteGift";
	/**
	 * 查询红包信息
	 */
	final static public String ACTIVITIE_HB_GIFT_QUERY = ACTIVITIE_GIFT+"queryActivitesHBGift";
	/**
	 * 查询2016元宵红包信息
	 */
	final static public String ACTIVITIE_YLYXHB_GIFT_QUERY = ACTIVITIE_GIFT+"queryActivitesYLYXHBGift";
	
	
	/**
	 * 微信红包
	 */
	final static public String addActivitiesWeChatGift = ACTIVITIE_GIFT+"addActivitiesWeChatGift";
	final static public String updateActivitesWeChatGift = ACTIVITIE_GIFT+"updateActivitesWeChatGift";
	
	/**
	 * 查询礼品信息
	 */
	final static public String ACTIVITIE_GIFT_QUERY = ACTIVITIE_GIFT+"queryActiviteGift";
	
	/**
	 * 百万财富发放统计
	 */
	final static public String ACTIVITIE_GIFT_MOLLIONS_WEALTH_COUNT = ACTIVITIE_GIFT+"mollionsWealthCount";
	
	/**
	 * 查询礼品信息(定时任务)
	 */
	final static public String ACTIVITIE_GIFT_QUERY_FORJOB = ACTIVITIE_GIFT+"queryActiviteGiftForJob";
	
	/**
	 * 添加wap产品预约
	 */
	final static public String ADD_ORDER_TMP = ORDER_TMP+"addOrderTmp";

	/**
	 * 添加产品收藏
	 */
	final static public String 	addProjectLike = PROJECT_LIKE+"addProjectLike";
	
	/**
	 * 查询产品收藏
	 */
	final static public String 	queryProjectLike = PROJECT_LIKE+"queryProjectLike";
	
	/**
	 * 删除产品收藏
	 */
	final static public String 	deleteProjectLike = PROJECT_LIKE+"deleteProjectLike";
	
	
	/**
	 * 查询活动详细
	 */
	final static public String PUBLIC_ACTIVITIES_QUERY = PUBLIC_ACTIVITIES+"queryPublicActivities";
	
	/**
	 * 添加活动
	 */
	final static public String PUBLIC_ACTIVITIES_ADD = PUBLIC_ACTIVITIES+"addPublicActivities";
	/**
	 * 修改活动
	 */
	final static public String PUBLIC_ACTIVITIES_UPDATE = PUBLIC_ACTIVITIES+"updatePublicActivities";
	/**
	 * 查询活动列表
	 */
	final static public String PUBLIC_ACTIVITIES_LIST = PUBLIC_ACTIVITIES+"publicActivitiesList";
	/**
	 * 查询活动列表
	 */
	final static public String PUBLIC_ACTIVITIES_LIST_COUNT = PUBLIC_ACTIVITIES+"publicActivitiesListCount";
	
	/**
	 * 查询活动列表
	 */
	final static public String PUBLIC_ACTIVITIES_PERSON_LIST = PUBLIC_ACTIVITIES_PERSON+"queryPublicActivitiesPerson";
	
	/**
	 * 添加活动参与人
	 */
	final static public String PUBLIC_ACTIVITIES_PERSON_ADD = PUBLIC_ACTIVITIES_PERSON+"addPublicActivitiesPerson";
	
	/**
	 * 添加用户行为信息
	 */
	final static public String  ADD_USER_TRACKING= USER_TRACKING + "addUserTracking";

	/**
	 * 添加用户反馈信息
	 */
	final static public String ADD_USER_FEED_BACK = USER_FEED_BACK+"addUserFeedBack";
	
	/**
	 * 查询亿起发广告代来的注册量
	 */
	final static public String  QUERY_AD_REG_INFO = USER_NAMESPACE+"queryADRegInfo";
	
	/**
	 * 产品被收藏的总次数
	 */
	final  static public String COUNT_PROJECT_LIKE = PROJECT_LIKE+"countProjectLike";
	
	/**
	 * 查询当前用户收藏的产品总数
	 */
	final static public String COUNT_PROJECT_LIKE_FOR_FA = PROJECT_LIKE +"countProjectLikeForFa";
	
	/**
	 * 查询当前用户分不同产品类型的收藏的产品总数（资管，pevc）
	 */
	final static public String COUNT_PROJECT_LIKE_PTYPE = PROJECT_LIKE +"countProjectLikePType";
	
	/**
	 * 查询当前用户分的收藏状态（pevc）
	 */
	final static public String PROJECT_LIKE_LIKE_TYPE = PROJECT_LIKE +"queryProjectLikeType";
	/**
	 * 个人红包总数
	 */
	final static public String COUNT_ACTIVITIES_GIFT = ACTIVITIE_GIFT + "countActivitiesGift";
	
	/**
	 * 查询最新订单
	 */
	final static public String QUERY_TOP_ORDER =  ORDER_NAMESPACE + "queryTopOrder";
	
	/**
	 * 查询fa成交订单总数
	 */
	final static public String COUNT_DEAL_ORDER = ORDER_NAMESPACE +"countDealOrder";
	
	/**
	 * 根据理财师ID查询订单管理员
	 */
	final static public String countOrderManagerForUserId = ORDER_NAMESPACE +"countOrderManagerForUserId";
	
	/**
	 * 查看所拥有理财师列表
	 */
	final static public String querySonFaidList = ORDER_NAMESPACE +"querySonFaidList";
	
	/**
	 * 根据邀请人查询查询订单管理人员
	 */
	final static public String queryOrderManagerUserBySource = ORDER_NAMESPACE +"queryOrderManagerUserBySource";
	
	/**
	 * 查询fa成交订单总数
	 */
	final static public String getOrderAmountCount = ORDER_NAMESPACE +"getOrderAmountCount";
	
	/**
	 * 删除客户信息
	 */
	final static public String DELETE_CLIENT_USER_BASE = CLIENT_NAMESPACE + "deleteClientUserBase";
	
	
	/** 
	 * 新增answer
	 */
	public final static String ANSWER_INSERT = ANSWER_TRACKING+"insertAnswer";
	
	/**
	 * 更新answer
	 */
	public final static String ANSWER_UPDATE_SESSIONID = ANSWER_TRACKING+"updateAnswerBySessionId";
	
	/**
	 * 查询answer根据sessionId
	 */
	public final static String ANSWER_SEARCH_SESSIONID = ANSWER_TRACKING+"searchAnswerBySessionId";
	
	
	/**
	 * 发财指数获取最高分数前TOP数
	 */
	public final static String ANSWER_SEARCH_RESULT_TOP = ANSWER_TRACKING+"searchAnswerResultTop";
	
	/**
	 * 发财指数参加总人数
	 */
	public final static String ANSWER_MONEY_JOIN_COUNT = ANSWER_TRACKING+"searchMoneyCount";
	
	/**
	 * 发财指数比自己分数高的人数
	 */
	public final static String ANSWER_MONEY_ANSWER_RANKING = ANSWER_TRACKING+"searchAnswerRanking";
	

	/**
	 * 一周内500的得奖数
	 */
	public final static String ANSWER_SEARCH_COUNT_ONE_WEEK = ANSWER_TRACKING+"searchCountOneWeek";
	
	/**
	 * 查询code获取活动信息
	 */
	public final static String ACTIVITES_SEARCH_BY_CODE = ACTIVITES_ACTIVITES+"searchActivitesByCode";
	
	/**
	 * 更新活动当前发放总金额
	 */
	public final static String ACTIVITES_UPDATE_AMOUNT_BY_CODE = ACTIVITES_ACTIVITES+"updateActivitesNowAmountByCode";
	
	/**
	 * 查询活动列表
	 */
	public final static String ACTIVITES_LIST_QUERY = ACTIVITES_ACTIVITES+"queryActivitesList";
	
	/**
	 * 查询活动扩展表
	 */
	public final static String ACTIVITES_SEARCH_EXPAND = ACTIVITES_ACTIVITES+"activitesSearchExpand";

	/**
	 * 添加银行卡
	 */
	final static public String BANK_CARD_ADD = BANK_CARD+"insertBankCard";
	/**
	 * 修改银行卡
	 */
	final static public String BANK_CARD_UPDATE = BANK_CARD+"updateBankCard";
	
	/**
	 * 查询银行卡列表
	 */
	final static public String BANK_CARD_LIST = BANK_CARD+"queryBankCardList";
	/**
	 * 查询银行卡
	 */
	final static public String BANK_CARD_INFO = BANK_CARD+"queryBankCardInfo";
	/**
	 * 查询银行卡
	 */
	final static public String BANK_CARD_INFOFORTYPE = BANK_CARD+"queryBankCardInfoForType";
	/**
	 * 验证银行卡
	 */
	final static public String BANK_CARD_CHECK_INFOF = BANK_CARD+"checkBankCardInfo";
	/**
	 * 统计是否有其他用户绑定过某张银行卡，并且处于有效0-非默认/1默认 (不是userId这个用户但绑定了bankCard这张卡,且正在生效的记录数)
	 */
	final static public String countOtherUserBindBankCard = BANK_CARD+"countOtherUserBindBankCard";
	
	/**
	 * 删除银行卡
	 */
	final static public String BANK_CARD_DELETE = BANK_CARD+"deleteBankCard";
	/**
	 * 添加账户提现记录
	 */
	final static public String ACCOUNT_WITHDRAW_ADD = ACCOUNT_WITHDRAW+"insertAccountWithdraw";
	
	/**
	 * 查询账户提现列表
	 */
	final static public String ACCOUNT_WITHDRAW_LIST = ACCOUNT_WITHDRAW+"queryAccountWithdrawList";
	/**
	 * 修改账户提现状态
	 */
	final static public String ACCOUNT_WITHDRAW_UPDATE = ACCOUNT_WITHDRAW+"updateAccountWithdraw";

	/**
	 * 查询产品公司列表
	 */
	final static public String QUERY_PROJECT_COMPANY = PROJECT_COMPANY+"queryProjectCompany";
	/**
	 * 查询公司详情
	 */
	final static public String QUERY_PROJECT_COMPANY_INFO = PROJECT_COMPANY+"queryProjectCompanyInfo";
	/**
	 * 查询公司产品总数
	 */
	final static public String QUERY_COMPANY_PRODCUTLIST_COUNT = PROJECT_COMPANY+"queryCompanyProdcutListCount";
	/**
	 * 查询公司产品列表
	 */
	final static public String QUERY_COMPANY_PRODCUTLIST = PROJECT_COMPANY+"queryCompanyProdcutList";
	
	/**
	 * 添加信息订阅
	 */
	final static public String ADD_INFO_SUBSCRIBE = INFO_SUBSCRIBE+"addInfoSubscribe";
	/**
	 * 查询信息订阅
	 */
	final static public String QUERY_INFO_SUBSCRIBE = INFO_SUBSCRIBE+"queryInfoSubscribe";
	/**
	 * 修改信息订阅
	 */
	final static public String UPDATE_INFO_SUBSCRIBE = INFO_SUBSCRIBE+"updateInfoSubscribe";
	
	
	/**
	 * 查询礼品信息
	 */
	final static public String QUERY_ADVERT = ADVERT+"queryAdvert";
	/**
	 * 查询礼品详情
	 */
	final static public String QUERY_ADVERT_INFO = ADVERT+"queryAdvertInfo";
	
	/**
	 * 查询广告位详情
	 */
	final static public String QUERY_ADVERT_LISTS = ADVERT+"queryAdvertLists";
	
	/**
	 * 友情链接查询列表
	 */
	final static public String queryListFriendshipLink = "fpFriendshipLink"+SEPARATOR+"queryList";
	
	/**
	 * 添加用户微信信息
	 */
	final static public String ADD_USERWECHAT = WECHAT+"addUserWechat";
	
	/**
	 * 查询用户微信信息
	 */
	final static public String QUERY_USERWECHAT_INFO = WECHAT+"queryUserWechatInfo";
	
	/**
	 * 修改用户微信信息
	 */
	final static public String UPDATE_USERWECHAT = WECHAT+"updateUserWechat";
	
	/**
	 * 网站地图SiteMap
	 */
	public static final String PRODCUT_SITEMAP_LIST = PRODUCT_NAMESPACE + "querySiteMapProjectList";
	public static final String FUND_SITEMAP_LIST = PRODUCT_NAMESPACE + "querySiteMapFundList";
	public static final String ACTIVITIES_SITEMAP_LIST = PRODUCT_NAMESPACE + "querySiteMapActivitiesList";
	public static final String PROJECTCOMPANY_SITEMAP_LIST = PRODUCT_NAMESPACE + "querySiteMapProjectCompanyList";
	
	public static final String queryProjectByPcode = "product.queryProjectByPcode";
	
	/**
	 * 查询百万财富活动产品
	 */
	final static public String QUERY_ACTIVITIES_MOLLIONS_WEALTH = ACTIVITIESMOLLIONSWEALTH + "queryActivitiesMollionsWealth";
	/**
	 * 活动中奖记录
	 */
	final static public String addActivitiesWinList = "activitiesWinList.addActivitiesWinList";
	final static public String deleteActivitiesWinList = "activitiesWinList.deleteActivitiesWinList";
	final static public String queryActivitiesWinListCount = "activitiesWinList.queryActivitiesWinListCount";
	final static public String queryActivitiesWinListList = "activitiesWinList.queryActivitiesWinListList";
    
    /**
	 * 短信广告模板内容
	 */
	final static public String querySMSADContent = "system.querySMSADContent";
	
	/**
	 * 查询邮件模板
	 */
	final static public String queryEmailTemplateByType = "emailTemplate.queryEmailTemplateByType";

/**
	 * 产品深度分析
	 */
	final static public String getFpProductDeepAnalyticsView = "productDeepAnalytics.getFpProductDeepAnalyticsView";
	final static public String QUERYHS300BYDATE="hs300.queryHS300List";
	final static public String insertHs300="hs300.insertHs300";
	
	/**
	 * 添加订单资料表
	 */
	final static public String addFpOrderPho="fpOrderPho.addFpOrderPho";
	/**
	 * 根据订单号查询产品订单资料表
	 */
	final static public String findProductOrderDatas="productOrderData.findProductOrderDatas";
	/**
	 * 根据订单号和图片类型查询产品订单资料表
	 */
	final static public String findFpOrderPhoResult="fpOrderPho.findFpOrderPhoResult";
	/**
	 * 显示资料是否审核完成
	 */
	final static public String checkFpOrderPhoStatus="fpOrderPho.checkFpOrderPhoStatus";
	/**
	 * 删除产品订单资料表
	 */
	final static public String deleteOrderPhoStatus="fpOrderPho.deleteOrderPhoStatus";
	/**
	 * 删除产品订单资料表
	 */
	final static public String queryManagerOrderByOid="fpmanagerOrder.queryManagerOrderByOid";
	
	/**
	 * 给订单管理员分配订单
	 */
	final static public String addManagerOrderUser = "managerOrder.addManagerOrderUser";
	final static public String addManagerOrderUserHistory = "managerOrder.addManagerOrderUserHistory";
	
	/**
	 * 查询该产品的数目
	 */
	final static public String findAllProductOrderPho="productOrderData.findAllProductOrderPho";
	
	/**
	 * 个人产品供应方
	 */
	//查询个人产品供应方
	final static public String queryProductSupplier = "productSupplier.queryProductSupplier";
	//新增个人产品供应方
	final static public String addProductSupplier = "productSupplier.addProductSupplier";
	//修改个人产品供应方
	final static public String updateProductSupplier="productSupplier.updateProductSupplier";
	
	/**
	 * 个人发布产品
	 */
	//查询个人发布产品
	final static public String queryforegroundProduct = "foregroundProduct.queryforegroundProduct";
	//新增个人发布产品
	final static public String addForegroundProduct = "foregroundProduct.addForegroundProduct";
	//修改发布产品 进度
	final static public String updateOutProduct="foregroundProduct.updateOutProduct";
	//修改发布产品
	final static public String	updateForegroundProduct="foregroundProduct.updateForegroundProduct";
	//查询个人发布产品总数
	final static public String countForegroundProduct = "foregroundProduct.countForegroundProduct";
	
	//修改销售规模
	final static public String updateProjectAnnualRevenueByendAmount = "foregroundProduct.updateProjectAnnualRevenueByendAmount";
	
	//产品修改日志
	final static public String addForegroundProductLog = "foregroundProduct.addForegroundProductLog";

	/**
	 * 通知
	 */
	// 查询
	final static public String getFaOrderNoticeByFa = "faNotice.getFaOrderNoticeByFa";
	final static public String getFaOrderNoticeByFaCount = "faNotice.getFaOrderNoticeByFaCount";
	
	final static public String queryProductNotice = "productNotice.queryProductNotice";
	final static public String queryProductNoticeCount = "productNotice.queryProductNoticeCount";
		/**
	 * 查询该类型下产品
	 */
	final static public String queryProductByType="product.queryProductByType";
	
	/**
	 *查询私募下所有产品名称
	 */
	final static public String queryProductBySimu = "fpFundInfo.queryProductByType";

/**
	 * 查询产品流水信息
	 */
	final static public String 	queryProjectFlow = PROJECT_LIKE+"queryProjectFlow";
	

	/**
	 * 产品关联来源列表
	 */
	final static public String getMediaSourceProduct = "product.getMediaSourceProduct";
	
	/**
	 * 产品被订阅的总次数
	 */
	final  static public String COUNT_PROJECT_SUB= PROJECT_LIKE+"querySubTimesBypId";
	
	/**
	 * 查询用户订阅产品
	 */
	final static public String 	queryProjectSubByuId = PROJECT_LIKE+"queryProjectSubByuId";

	final static public String countProjectFlow=PROJECT_LIKE+"countProjectFlow";
	/**
	 * 根据产品查询是否订阅
	 */
	public static final String queryProductSubBypId = PRODUCT_NAMESPACE + "queryProductSubBypId";
	/**
	 * 根据参数查询用户信息来发送邮件
	 */
	public static final String USER_QUERY_TO_SEND_EMAIL = USER_NAMESPACE + "queryUserToSendEmail";
	
	/**
	 * 查询所有团队名称
	 */
	public static final String queryActivitiesGroupNames = ACITIVIES_GROUP_NAME+"queryAcititesGroupNames";
	
	/**
	 * 查询个人zt1000所有红包总金额
	 */
	public static final String queryOneUserAllGiftAmount = ACTIVITIES_GROUP+"queryOneUserAllGiftAmount";

	/**
	 * 更新团名称
	 */
	public static final String updateActivitiesGroupName = ACTIVITIES_GROUP+"updateActivitiesGroupName";
	
	
	/**
	 * 查询用户为领取红包总金额
	 */
	public static final String queryOneUserNotGetGiftAmount = ACTIVITIES_GROUP+"queryOneUserNotGetGiftAmount";
	
	/**
	 * 查询需要定时任务处理的团
	 */
	public static final String queryActivitiesGroupJob  = ACTIVITIES_GROUP+"queryActivitiesGroupJob";
	
	/**
	 * 查询自己组建的团信息
	 */
	public static final String queryActivitiesOwnGroup = ACTIVITIES_GROUP+"queryActivitiesOwnGroup";
	
	
	/**
	 * 查询团信息
	 */
	public static final String  queryActivitiesGroup = ACTIVITIES_GROUP+"queryActivitiesGroup";
	
	/**
	 * 查询分享页面团信息
	 */
	public static final String queryShareActivitiesGroup = ACTIVITIES_GROUP +"queryShareActivitiesGroup";
	
	/**
	 * 更新团信息
	 */
	public static final String updateActivitiesGroup = ACTIVITIES_GROUP+"updateActivitiesGroup";
	
	/**
	 * 添加团成员或者新建团
	 */
	public static final String addActivitiesGroup = ACTIVITIES_GROUP+"addActivitiesGroup";
	
	/**
	 * 查询组通过认证的人数
	 */
	public static final String  queryActivitiesGroupSuccess = ACTIVITIES_GROUP+"queryActivitiesGroupSuccess";
	
	/**
	 * 查询组成员详细信息
	 */
	public static final String queryActivitiesGroupMemberInfo = ACTIVITIES_GROUP+"queryActivitiesGroupMemberInfo";
	
	/**
	 * 查询金额发放金额明细
	 */
	public static final String queyActivitiesGroupGift = ACTIVITIES_GROUP+"queyActivitiesGroupGift";
	
	//支付银行信息
	public class BankInfoSql{
		
		private static final String BANKINFO = "bankInfo"+SEPARATOR;
		
		public static final String queyBankInfoList = BANKINFO+"queryBankInfoList";
	}
	
	//支付流水
	public class PaymentSql{
		
		private static final String PAYMENT = "payment"+SEPARATOR;
		
		public static final String addPayment = PAYMENT+"addPayment";
		public static final String queryPayment = PAYMENT+"queryPayment";
		public static final String updatePayment = PAYMENT+"updatePayment";
		public static final String queryPaymentList = PAYMENT+"queryPaymentList";
		public static final String queryPaymentListCount = PAYMENT+"queryPaymentListCount";
		public static final String addPaymentbaofoorsp = PAYMENT+"addPaymentbaofoorsp";//宝付支付响应
	}
	
	//用户
	public class FaUserSql{
		
		public static final String updateFaUser = USER_NAMESPACE+"updateFaUser";
		public static final String updateFaUserForce = USER_NAMESPACE+"updateFaUserForce";
		public static final String queryFaImage = USER_NAMESPACE+"queryFaImage";
	}
	
	//用户银行卡
	public class FaUserBankCardSql{
		
		final static public String queryUserBindedcardList = BANK_CARD+"queryUserBindedcardList";
	}


	/**
	 * 查询收单产品条数
	 */
	public static final String queryMyYouDanProjectListCount = ORDER_NAMESPACE + "queryMyYouDanProjectListCount";
	/**
	 * 查询收单产品
	 */
	public static final String queryMyYouDanProjectList = ORDER_NAMESPACE + "queryMyYouDanProjectList";
	
	public static final String getYouDanReservedAmountByProjectId = ORDER_NAMESPACE + "getYouDanReservedAmountByPId";
	public static final String getYouDanConfirmedAmountByProjectId = ORDER_NAMESPACE + "getYouDanConfirmedAmountByPId";
	public static final String getMyYouDanOrderAllRebateAmount = ORDER_NAMESPACE + "getMyYouDanOrderAllRebateAmount";
	public static final String getPayingCommission = ORDER_NAMESPACE + "getPayingCommission";
	public static final String getPayedCommission = ORDER_NAMESPACE + "getPayedCommission";
	public static final String getYouDanOrderListCount = ORDER_NAMESPACE + "getYouDanOrderListCount";
	public static final String getYouDanOrderList = ORDER_NAMESPACE + "getYouDanOrderList";
	public static final String getYouDanOrderDetail = ORDER_NAMESPACE + "getYouDanOrderDetail";
	public static final String getYouDanCommissionByProduct = ORDER_NAMESPACE + "getYouDanCommissionByProduct";
	public static final String getProduct = ORDER_NAMESPACE + "getProduct";	
	
	//支付流水
	public class YouDanAmountDetailSql{
		
		private static final String YOUDANAMOUNTDETAIL = "youDanAmountDetail"+SEPARATOR;
		
		public static final String addYouDanAmountDetail = YOUDANAMOUNTDETAIL+"addYouDanAmountDetail";
		public static final String queryYouDanAmountDetailList = YOUDANAMOUNTDETAIL+"queryYouDanAmountDetailList";
		public static final String updateYouDanAmountDetail = YOUDANAMOUNTDETAIL+"updateYouDanAmountDetail";
	}
	public static final String getYouDanAmountByOrder = ORDER_NAMESPACE + "getYouDanAmountByOrder";
	
	/**
	 * 新增有单金额明细
	 */
	final static public String insertYouDanAmount  = "youDanAmount.insertYouDanAmount";
	/**
	 * 更新有单金额明细
	 */
	final static public String updateYouDanAmount  = "youDanAmount.updateYouDanAmount";
	/**
	 * 查询有单金额明细
	 */
	final static public String getYouDanAmount  = "youDanAmount.getYouDanAmount";

	public static final String getBaoZhengJinAmount = "youDanAmount.getBaoZhengJinAmount";
	public static final String getCommissionAmount = "youDanAmount.getCommissionAmount";
	/**
	 * 查询竞价佣金
	 */
	public static final String myBiddingProjectCommission = ORDER_NAMESPACE + "myBiddingProjectCommission";
	
	/**
	 * 根据返佣ID查产品
	 */
	final static public String getProductByReceiptId  = "youDanAmount.getProductByReceiptId";
	/**
	 * 根据订单ID查产品
	 */
	final static public String getProductByOrderId  = "youDanAmount.getProductByOrderId";
	
	public static final String getYouDanAmountCount = "youDanAmount.getYouDanAmountCount";
	/**
	 * 出单-查询我的出单 非有单订单佣金
	 */
	public static final String getMyOrderFrontRebateAmount = ORDER_NAMESPACE + "getMyOrderFrontRebateAmount";
	public static final String getMyOrderBackRebateAmount = ORDER_NAMESPACE + "getMyOrderBackRebateAmount";
	/**
	 * 出单-查询有单订单佣金
	 */
	public static final String getMyAllOrderRebateAmount = ORDER_NAMESPACE + "getMyAllOrderRebateAmount";
	/**
	 * 查询交易通知的更新时间
	 */
	final static public String getFaOrderNoticeUpdateDateByFa = "faNotice.getFaOrderNoticeUpdateDateByFa";
	/**
	 * 查询订阅产品的更新时间
	 */
	final static public String getPrijectLikeUpdateDateByFa=PROJECT_LIKE+"getPrijectLikeUpdateDateByFa";
	/**
	 * 查询最新公告的更新时间
	 */
	public static final String getNewsUpdateDate= NEWS_NAMESPACE + "getNewsUpdateDate";
	
	/**
	 * 查询用户极光推送手机别名
	 */
	public static final String queryMessageJpushUserPhoneAlias = MESSAGEJPUSHUSERPHONEALIAS+"queryMessageJpushUserPhoneAlias";
	
	/**
	 * 添加极光推送消息
	 */
	public static final String addMessageJpush = MESSAGEJPUSHUSERPHONEALIAS+"addMessageJpush";

	/**
	 * 查询用户极光推送手机别名
	 */
	public static final String queryMessageJpushUserPhoneAliasInfo = MESSAGEJPUSHUSERPHONEALIAS+"queryMessageJpushUserPhoneAliasInfo";

	/**
	 * 添加用户极光推送手机别名
	 */
	public static final String addMessageJpushUserPhoneAlias = MESSAGEJPUSHUSERPHONEALIAS+"addMessageJpushUserPhoneAlias";
	
	/**
	 * 更新用户极光推送手机别名
	 */
	public static final String updateMessageJpushUserPhoneAlias = MESSAGEJPUSHUSERPHONEALIAS+"updateMessageJpushUserPhoneAlias";
	
	//支付错误代码
	public class PaymentErrormsgSql{
			
			private static final String PAYMENTERRORMSG = "paymentErrormsg"+SEPARATOR;
			
			public static final String queryPaymentErrormsg = PAYMENTERRORMSG+"queryPaymentErrormsg";
	}
	/**
	 * 查询交易通知的更新时间
	 */
	final static public String readFaNoticeByFa = "faNotice.readFaNoticeByFa";
	/**
	 * 查询最新公告的更新时间
	 */
	public static final String updateLastNewsDate= NEWS_NAMESPACE + "updateLastNewsDate";
	
	
		/**
	 * 添加用户私募管理办法记录
	 */
	public static final String addUserAgreeAgreement = USERAGREEAGREEMENT+"addUserAgreeAgreement";
	
	/**
	 * 查询用户私募管理办法记录
	 */
	public static final String queryUserAgreeAgreement = USERAGREEAGREEMENT+"queryUserAgreeAgreement";
	
	/**
	 *  更新用户私募管理办法记录
	 */
	public static final String updateUserAgreeAgreement = USERAGREEAGREEMENT+"updateUserAgreeAgreement";
	
	/**
	 * 查询最新极光推送的更新时间
	 */
	public static final String getJPushUpdateDate= NEWS_NAMESPACE + "getJPushUpdateDate";

    /**
     * 查询最新极光推送的更新时间
     */
    public static final String getJPushShopUpdateDate= NEWS_NAMESPACE + "getJPushShopUpdateDate";

    /**
     * 查询最新极光推送的更新时间-店铺消息
     */
    public static final String updateLastJPushShopDate= NEWS_NAMESPACE + "updateLastJPushShopDate";
	
	/**
	 * 查询最新极光推送的更新时间
	 */
	public static final String updateLastJPushDate= NEWS_NAMESPACE + "updateLastJPushDate";
	
	/**
	 *资讯列表数
	 */
	public static final String getJPushList= NEWS_NAMESPACE + "getJPushList";

	/**
	 *资讯列表数总数
	 */
	public static final String getJPushListCount= NEWS_NAMESPACE + "getJPushListCount";

    /**
     *资讯列表数-店铺
     */
    public static final String getJPushListShop= NEWS_NAMESPACE + "getJPushListShop";

    /**
     *资讯列表数总数-店铺
     */
    public static final String getJPushListShopCount= NEWS_NAMESPACE + "getJPushListShopCount";
	//后台用户
	public class UserInfoSql{
			
			public static final String queryUserInfo = "userInfo.queryUserInfo";
			
			public static final String queryUserInfoForLicaishi = "userInfo.queryUserInfoForLicaishi";
			//查询当前用户下属用户phone
			public static final String queryPhoneLayerPath = "userInfo.queryPhoneLayerPath";
			
			public static final String queryUseridByLayerPath = "userInfo.queryUseridByLayerPath";
			
			public static final String queryOrgTree = "userInfo.queryOrgTree";
			
	}
	
	//分配理财师
	public class ManagerLicaishiSql{
			
		/**
		 * 分配理财师给服务顾问
		 */
		final static public String addManagerLicaishiUser = "managerLicaishi.addManagerLicaishiUser";
		final static public String addManagerLicaishiUserHistory = "managerLicaishi.addManagerLicaishiUserHistory";
		/**
		 * 理财师服务顾问权限修改 
		 */
		final static public String updateManagerLicaishiUser = "managerLicaishi.updateManagerLicaishiUser";
		final static public String queryManagerLicaishiByUser = "managerLicaishi.queryManagerLicaishiByUser";
		final static public String countManagerLicaishiByUser = "managerLicaishi.countManagerLicaishiByUser";
		final static public String queryManagerLicaishiByForFirst = "managerLicaishi.queryManagerLicaishiByForFirst";
		
		//回收理财师列表查询
		final static public String queryManagerLicaishiJob="managerLicaishi.queryManagerLicaishiJob";
	}
	
	//FA人员说说
	public class FpFaUserSaysaySql{
			
			private static final String namespace = "fpFaUserSaysay"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
		
	//路演视频
	public class FpVideoSql{
			
			private static final String namespace = "fpVideo"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryVideoInfo = namespace+"queryVideoInfo";
			
			
	}
	//路演视频记录表
	public class FpVideoHisSql{
			
			private static final String namespace = "fpVideoHis"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//sfa活动-金融相亲表
	public class FpHdFinancingBlindSql{
			
			private static final String namespace = "fpHdFinancingBlind"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String loadByMobile = namespace+"loadByMobile";
			
	}
	//用户店铺添加的产品
	public class FpShopperProductSql{
			
			private static final String namespace = "fpShopperProduct"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String shopperProdcutList = namespace+"shopperProdcutList";
			
			public static final String shopperProdcutListCount = namespace+"shopperProdcutListCount";
			
	}
	
	//用户手机端客户
	public class FpPhoneClientSql{
			
			private static final String namespace = "fpPhoneClient"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			//查询微信是否已添加到客户
			public static final String queryWechatAndFlagAdd = namespace+"queryWechatAndFlagAdd";
	}
	//客户的活动表
	public class FpClientActivitySql{
			
			private static final String namespace = "fpClientActivity"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//客户活动报名用户
	public class FpClientActivityUserSql{
			
			private static final String namespace = "fpClientActivityUser"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//理财师店铺订单
	public class FpClientOrderSql{
			
			private static final String namespace = "fpClientOrder"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String queryListTimes = namespace+"queryListTimes";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String orderCont = namespace+"orderCont";
			
			public static final String orderContByUserId = namespace+"orderContByUserId";
	}
	
	//理财师-地址管理
	public class FpFaUserAddressSql{
			
			private static final String namespace = "fpFaUserAddress"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//店铺基本资料
	public class ShopperUserInfoSql{
			
			private static final String namespace = "shopperUserInfo"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//说说评论表
	public class FpFaUserSaysayCommentSql{
			
			private static final String namespace = "fpFaUserSaysayComment"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//融云消息记录
	public class FpRyMessageLogSql{
			
			private static final String namespace = "fpRyMessageLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//理财师-合同管理
	public class FpFaUserContractSql{

		private static final String namespace = "fpFaUserContract"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	
	//shop人员信息表
	public class FpFaUserDataSql{
			
			private static final String namespace = "fpFaUserData"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//工具活动抽奖用户表
	public class FpShopActivityUserSql{
			
			private static final String namespace = "fpShopActivityUser"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}

	//理财师工具用户自有产品表
	public class FpShopUserRelProductSql{
			
			private static final String namespace = "fpShopUserRelProduct"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//理财师工具用户自有产品表详情
	public class FpShopUserRelProductDetailSql{
			
			private static final String namespace = "fpShopUserRelProductDetail"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//自有产品分类
	public class FpShopProductTypeSql{
			
			private static final String namespace = "fpShopProductType"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//店铺题目表
	public class FpShopSubjectSql{
			
			private static final String namespace = "fpShopSubject"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//用户答题表
	public class FpShopSubjectUserSql{
			
			private static final String namespace = "fpShopSubjectUser"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//背景图片表
	public class FpShopBackgroundSql{
			
			private static final String namespace = "fpShopBackground"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//用户背景图片表
	public class FpShopUserBackgroundSql{
			
			private static final String namespace = "fpShopUserBackground"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户反馈
	public class FpFaUserFeedbackSql{
			
			private static final String namespace = "fpFaUserFeedback"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//资讯信息
		public class FpShopInformationSql{
			
			private static final String namespace = "fpShopInformation"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryCurdayInformations = namespace+"queryCurdayInformations";
	    }
		//金融指数日志
		public class CompositeIndexLogSql{
				
				private static final String namespace = "compositeIndexLog"+SEPARATOR;
				
				public static final String insert = namespace+"insert";
				
				public static final String update = namespace+"update";
				
				public static final String updateForce = namespace+"updateForce";
				
				public static final String queryList = namespace+"queryList";
				
				public static final String queryListCount = namespace+"queryListCount";
				
				public static final String loadById = namespace+"loadById";
				
				public static final String delete = namespace+"delete";
				
				public static final String queryCompositeByCurtime = namespace+"queryCompositeByCurtime";
		}
		//早鸟驿站签到
		public class FpShopSigninSql{
				
				private static final String namespace = "fpShopSignin"+SEPARATOR;
				
				public static final String insert = namespace+"insert";
				
				public static final String update = namespace+"update";
				
				public static final String updateForce = namespace+"updateForce";
				
				public static final String queryList = namespace+"queryList";
				
				public static final String queryListCount = namespace+"queryListCount";
				
				public static final String loadById = namespace+"loadById";
				
				public static final String delete = namespace+"delete";
				
				public static final String querySortByTotal = namespace+"querySortByTotal";
				
				public static final String querySortByTime = namespace+"querySortByTime";
				
				public static final String queryTopTen = namespace+"queryTopTen";
				
		}
		//金策师资讯点赞
		public class FpShopInformationDzSql{
			
			private static final String namespace = "fpShopInformationDz"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	    }
	//奖项配置表
	public class SalesPrizesSql{
			
			private static final String namespace = "salesPrizes"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			//随机抽奖
			public static final String queryListSend=namespace+"queryListSend";
			//已中奖名单
			public static final String salesPrizesPeopleList=namespace+"salesPrizesPeopleList";
	}
	//抽奖记录
	public class SalesPrizesLogSql{
			
			private static final String namespace = "salesPrizesLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	
	
	//销售抽奖人数
	public class SalesPrizesPeopleSql{
			
			private static final String namespace = "salesPrizesPeople"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//产品资讯关联表
	public class FpShopProjectInformationSql{
			
			private static final String namespace = "fpShopProjectInformation"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//金策师直播平台开通申请
	public class FpShopPlayopenApplySql{
			
			private static final String namespace = "fpShopPlayopenApply"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
}
